<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title>新闻管理</title>
		<script type="text/javascript">
			function doDel(id){
				if(confirm("确定删除?")){
					//跳转
					window.location.href="action.php?a=del&id="+id;
				}
			}
		</script>
			<link href="../include/css/css.css" type="text/css" rel="stylesheet" />
			<link href="../include/css/main.css" type="text/css" rel="stylesheet" />
			<link rel="shortcut icon" href="../include/images/main/favicon.ico" />
			<style>
			body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
			#searchmain{ font-size:12px;}
			#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
			#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
			#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
			#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(../include/images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
			#search a.add{ background:url(../include/images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
			#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
			#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
			#main-tab th{ font-size:12px; background:url(../include/images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
			#main-tab td{ font-size:12px; line-height:40px;}
			#main-tab td a{ font-size:12px; color:#548fc9;}
			#main-tab td a:hover{color:#565656; text-decoration:underline;}
			.bordertop{ border-top:1px solid #ebebeb}
			.borderright{ border-right:1px solid #ebebeb}
			.borderbottom{ border-bottom:1px solid #ebebeb}
			.borderleft{ border-left:1px solid #ebebeb}
			.gray{ color:#dbdbdb;}
			td.fenye{ padding:10px 0 0 0; text-align:right;}
			.bggray{ background:#f9f9f9}
			table td{white-space:nowrap;overflow:hidden; text-overflow:ellipsis;}
			table {table-layout:fixed;} 
	</style>
	</head>
<body>
<!--main_top-->
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
  <tr>
    <td width="99%" align="left" valign="top">您的位置：浏览新闻</td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
	  <tr>
        <th align="center" valign="middle" class="borderright" width="5%">编号</th>
        <th align="center" valign="middle" class="borderright" width="15%">新闻标题</th>
        <th align="center" valign="middle" class="borderright" width="45%">新闻内容</th>
        <th align="center" valign="middle" class="borderright" width="15%">新闻来源</th>
        <th align="center" valign="middle" class="borderright" width="10%">发布时间</th>
        <th align="center" valign="middle" width="10%">操作</th>
      </tr>
	  <?php
			date_default_timezone_set("PRC");//设置时间
			require("../../public/config.php");		//导入配置文件
			
			$link = mysqli_connect(HOST,USER,PASS,DBNAME) or die("连接数据库失败");
			
			mysqli_set_charset($link,"utf8");	//设置数据库编码
			$sql = "select * from news";
			$result =  mysqli_query($link,$sql);	
			while($row = mysqli_fetch_assoc($result)){	//遍历并输出
				echo  '<tr onMouseOut="this.style.backgroundColor=\'#ffffff\'" onMouseOver="this.style.backgroundColor=\'#edf5ff\'">';
				echo	'<td align="center" valign="middle" class="borderright borderbottom">'.$row['id'].'</td>';
				echo 	'<td align="center" valign="middle" class="borderright borderbottom">'.$row['name'].'</td>';
				echo 	'<td align="center" valign="middle" class="borderright borderbottom"><nobr>'.$row['connect'].'</nobr></td>';
				echo 	'<td align="center" valign="middle" class="borderright borderbottom">'.$row['ly'].'</td>';
				echo 	'<td align="center" valign="middle" class="borderright borderbottom">'.date("Y-m-d H:i:s",$row['addtime']).'</td>';
				echo	'<td align="center" valign="middle" class="borderbottom">
						 <a href="edit.php?id='.$row['id'].'" target="mainFrame" onFocus="this.blur()" class="add">编辑</a>
						<span class="gray">&nbsp;|&nbsp;</span>
						<a href="javascript:doDel('.$row['id'].')" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>';
				echo  "</tr>";
			}
			
		?>
      
    </table>
</table>
</body>
</html>